Repositories, rpm, Binary Tarball, Source Tarball, Git Source Tree, etc. You can select the appropriate method based on the actual environment. For detailed installation steps, see the official documentation. The following describes how to install the rpm package on RHEL 6.Installing
Percona ServerUsing rpm packages1 download package
Wget https://www.percona.com/downloads/
Install Percona Server using a binary tar package
Install Percona Server using a binary tar package
InstallingPercona ServerFrom a Binary Tarball1. Download the binary tar package
Take version 5.6 as an example. Go to the official website https://www.percona.com/downloads/percona-server-5.6/latest/and you can see the f
flaws that exist in MySQL. Their upgrade document is three words to describe is "too simple", in order to take some steps to clear, but also for me to take a little detour, I still take my upgrade step detailed list, for later review it.This upgrade I started from the installation of Percona Server instance, because the Percona configuration file and MySQL is still partially different, the novice with the
Percona-toolkit installation and introduction, percona-toolkit
MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many powerful third-party derivative products, such as percona-toolkit and XtraBackup.
-related modules
The PT tool is written and executed in Perl and requires a Perl environment in the system.
The Dependency Pack Check command is:
Rpm-qa perl-dbi perl-dbd-mysql perl-time-hires Perl-io-socket-ssl
If you have a dependency package, you can install it using the following command:
Yum Install PERL-DBI
Yum Install Perl-dbd-mysql
Yum Install Perl-time-hires
Yum Install Perl-io-socket-ssl
download and install of 2.
Install Percona Server using the source code package
Install Percona Server using the source code package
1. Download the source code tar package.
Https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/source/tarball/
/var/lib/mysql_mariadb
4. Install Percona using binary package
You can choose among the many Percona installation methods, the use of Yum or RPM package installation in CentOS is usually a better idea, so these are the ways described in this article, download the source files compiled after the installation is not described in this article.
To install from the
runtime environment, here directly choose to install with Yum to meet the requirements:CentOS System Installation:#yum install-y PHP Php-mysqlUbuntu System Installation:#sudo apt-get Install php-* php-mysqlEnsure that the monitored host does not have Percona related software installed, if any, uninstall it!#rpm-qa|grep Percona2) Download the official Percona tem
described in this article, and the download source files are compiled and installed in this article and are not described.Install from the Yum repository:First, you need to set up the Percona Yum Library:Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpmNext Inst
described in this article, and the download source files are compiled and installed in this article and are not described.Install from the Yum repository:First, you need to set up the Percona Yum Library:Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpmNext Inst
these are the methods described in this article, download the source file and install it in this article.
Install from the Yum Repository:
First, you need to set the Yum library of Percona:
Yuminstallhttp: // www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Next, install
install and do basic configuration for Percona Server.2. Back up your databaseNext, use the SQL command on the command line to create a mydatabases. SQL file to recreate or restore the salesdb and employeedb databases. Replace the database name according to your settings. Skip this step if MySQL is not installed:Mysqldump-u root-p -- databases employeedb salesdb> mydatabases. SQLCopy the current configuration file. Skip this step if you have not inst
1. percona-toolkit Introduction
Percona-toolkit is a set of advanced command line tools used to execute various complicated and troublesome mysql and system tasks by hand, including:
Check master and slave Data Consistency
Effectively archive records
Searching duplicate Indexes
Summarize Server Information
Analyze queries from logs and tcpdump
Collect important system information when a system problem occur
Tags: Moni suitable for%s local client interval logon 2.0 causesSystem RequirementsMonitored host and MySQL monitoring account, Zabbix Agent 2.0 or more (preferably the same as the Zabbix-server version), PHP, Php-mysql (PHP version is not limited, tested 5.3 is possible. The best version is not too low), Percona monitoring Plugins for ZabbixInstalling the Zabbix AgentHttps://www.cnblogs.com/fishparadise/p/9067471.htmlInstalling
MySQL High-availability PXC (Percona XtraDB Cluster)ReferenceHttp://www.cnblogs.com/xiaoboluo768/p/5135619.htmlThe server environment information is as follows:Node1 192.168.0.100Node2 192.168.0.101Node3 192.168.0.1021. Install the Software dependency package (add Repl source, install dependencies, and 3 server operations. )[Email protected] ~]# RPM-IVH http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm[email protected] ~]# Yum
[MySQL tool] use percona-toolkit (1) source code to install bitsCN.com
[MySQL tool] percona-toolkit (1) source code installation
1. percona-toolkit introduction
Percona-toolkit is a set of advanced command line tools used to execute various complicated and troublesome mysql and system tasks by hand, including:
L chec
Tags: centos7 PXC linux MySQLOperating system Centos7.4,mysql installed under/data/mysql, MySQL belongs to MySQL user1. Download the source packageDownload pxc-5.7.19Mkdir-p/home/sunx/toolsHttps://www.percona.com/downloads/Percona-XtraDB-Cluster-57/Percona-XtraDB-Cluster-5.7.19-29.22/source/tarball /percona-xtradb-clus
Tags: water client awk 40 cal success Title init milZabbix with plugin Percona monitor MySQL dataIn the sense of Zabbix the MySQL plugin to monitor the MySQL database, but you will find that the MySQL monitoring items are very few, can not meet the needs of the company.Because its own template is too simple, so need to do more detailed monitoring, and Percona provides this detailed monitoring template and s
Tags: OpenSSL 2.4 process database passwd adb body lower caseFirst, the environmentCentOS release 6.9Percona-XtraDB-Cluster-5.7.19-29.22.tar.gzboost_1_59_0.tar.gzpercona-xtrabackup-24-2.4.7-1.el6.x86_64.rpm
node
MySQL Service port
Gmcast.listen Port
node01:192.168.1.210:6600
6600
6630
node02:192.168.1.210:6602
6602
6632
Node03:gardb
No
5567
Second,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.